﻿CREATE PROCEDURE [dbo].[sp_UpdateInstanceMapping] 
	@componentId int,
	@sourceColumnName nvarchar(256),
	@sourceColumnUsage	bit,
	@destinationColumnName nvarchar(256)
AS 
BEGIN
UPDATE InstanceMappings SET SourceColumnUsage = @sourceColumnUsage, DestinationColumnName = @destinationColumnName WHERE ComponentId = @componentId AND SourceColumnName = @sourceColumnName; 
END


